﻿CREATE TABLE [dbo].[Projekt1] (
    [ProjektKey]     INT           IDENTITY (1, 1) NOT NULL,
    [ProjektTS]      NVARCHAR (18) COLLATE Latin1_General_CI_AS NULL,
    [ProjektNummer]  NVARCHAR (30) COLLATE Latin1_General_CI_AS NULL,
    [StatusKey]      INT           DEFAULT ((0)) NULL,
    [Änderung]       DATETIME      NULL,
    [Datum]          DATETIME      NULL,
    [Sachbearbeiter] INT           DEFAULT ((0)) NULL,
    [Statistik]      BIT           DEFAULT ((0)) NULL,
    [Abrechnung]     BIT           DEFAULT ((0)) NULL,
    [Aktuell]        BIT           DEFAULT ((0)) NULL,
    [Leistungen]     BIT           DEFAULT ((0)) NULL,
    [ProjektVersion] INT           DEFAULT ((0)) NULL,
    [Notiz]          NTEXT         COLLATE Latin1_General_CI_AS NULL,
    CONSTRAINT [PK_Projekt1] PRIMARY KEY CLUSTERED ([ProjektKey] ASC)
);

